-- phpMyAdmin SQL Dump
-- version 4.9.5deb2
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Jul 03, 2022 at 09:53 PM
-- Server version: 8.0.29-0ubuntu0.20.04.3
-- PHP Version: 7.4.3

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `team0`
--

-- --------------------------------------------------------

--
-- Table structure for table `iro-gis`
--

CREATE TABLE `iro-gis` (
  `indice` int NOT NULL,
  `tipo` int DEFAULT NULL,
  `fecha` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `ip` varchar(15) DEFAULT NULL,
  `coordenadas` varchar(20) DEFAULT NULL,
  `proveedor` varchar(20) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `fichero` varchar(100) DEFAULT NULL,
  `observaciones` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `iro-gis`
--

INSERT INTO `iro-gis` (`indice`, `tipo`, `fecha`, `ip`, `coordenadas`, `proveedor`, `email`, `fichero`, `observaciones`) VALUES
(1, 1, '2022-03-01 18:00:00', '158.42.58.11', '39.48322,-0.34377', 'network', 'edblata@upvnet.upv.es', 'app_inventor_1519412405242.jpg', 'Hello everybody!'),
(2, 1, '2022-03-02 13:35:00', '158.42.82.28', '39.457706, -0.354171', 'manual', 'edblata@upv.es', 'DSC_8110-001.JPG', 'The City of Arts and Sciences of Valencia'),
(1182, 1, '2022-04-03 19:38:36', '77.205.41.64', '39.453475, -0.346862', 'gps', 'john@univ-brest.fr', 'picked_image8399323861630016749.jpg', 'Oceanografic '),
(1188, 1, '2022-05-19 09:33:09', '95.127.35.236', '39.48363,-0.34629', 'gps', 'rapasae@upvnet.upv.es', 'app_inventor_1652952752670.png', 'testing');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `iro-gis`
--
ALTER TABLE `iro-gis`
  ADD PRIMARY KEY (`indice`),
  ADD UNIQUE KEY `indice` (`indice`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `iro-gis`
--
ALTER TABLE `iro-gis`
  MODIFY `indice` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1192;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
